import pandas
import pandas as pd

columns = ['Inventory Asset', 'Date', 'Transaction Type', 'Num', 'Name', 'Memo/Description', 'Qty', 'Rate', 'Amount',
           'Balance']
data = pandas.read_excel('data.xlsx', names=columns, engine='openpyxl')
data = data.loc[5:]
# data = data.drop('Inventory Asset', axis=1)
print(data.iloc[0,])
data.to_excel('demo.xlsx', index=False)
